create external table jms_dm.dm_daily_waybill_weight_difference_sum_dt
(
       subordinate_agent_id string COMMENT'所属代理区ID',
       subordinate_agent_code string comment'所属代理区coed',
       subordinate_agent_name string comment'所属代理区名字',
       city_id string comment'所属城市ID',
       city_desc string comment'所属城市名字',
       code string comment'所属网点code',
       name string comment'所属网点名字',
       day_abnormal_sum bigint comment'每日网点异常运单量',
       site_day_waybill_sum bigint comment'每日网点总单量',
       input_date string  comment'日期',
       active_abnormal_sum  bigint comment'有效异常数据',
       reweigh_sum int  comment '复称总票数'
)
    COMMENT '称重差异明细'
    PARTITIONED BY ( dt STRING COMMENT '分区日期')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_daily_waybill_weight_difference_sum_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );

--修改语句
-- alter table jms_dm.dm_daily_waybill_weight_difference_sum_dt add columns (reweigh_sum int  comment '复称总票数') cascade ;